package utils.db.api;

import java.util.List;

import pojo.Device;
import pojo.EUserType;
import pojo.User;

public interface ISearch {
	public List<Device> searchDevices(String search, EUserType type, int clientId);
	public List<User> searchUsers(String search);
	
	public String SEARCH_USER="select * from users where firstName like ? or lastName like ? or email like ? or phoneNumber like ? or type like ?";
	public String SEARCH_DEVICE_CLIENT="select * from devices where (description like ? or type like ? or state like ?) and client_id=?";
	public String SEARCH_DEVICE_SERVICEMAN="select * from devices where (description like ? or type like ? or state like ?) and serviceman_id=?";
	public String SEARCH_DEVICE_ADMIN="select * from devices where description like ? or type like ? or state like ?";
}
